嘿伙计们，我们回来了，我们已经让这件事运行了一段时间了。
Hey guys we are back and we've had this thing running for a little bit.

那么让我们看看我们是否正在记录我们应该记录的数据。
So let's see if we are logging the data that we are supposed to be logging.

所以我要按 Alt-Tab 离开这里。
So I'm going to Alt-Tab out of here.

我们回到了续集 Server Management Studio，何时右键单击我的 C3 数据库并刷新，当我查看表时，我只看到一个新表，而没有看到我的反洗表，因此这已经是一个坏兆头。
And we are back into sequel Server Management Studio and when to right click on my C3 database and refresh and when I look in tables I'm only seeing one new table I'm not seeing my backwash table so that's already a bad sign.

然后，让我们右键单击周期性的 Andrle，继续获取前 200 行。
Then let's right click on periodic Andrle go ahead and take this top 200 rows.

我们还有另一个不好的迹象。
And we've got another bad sign.

现在我们应该有几行，但看起来我们只有一行。
By now we should have several rows and it looks like we only have one.

我离开的时间绝对超过 20 甚至 30 分钟。
I've definitely been gone longer than 20 or even 30 minutes.

因此，让我们关闭这里，我们根本没有获得反冲洗数据，因此您可以退出应用程序，我们需要找出原因。
So let's close out of here and we're not getting our backwash data at all so you can just exit out of the app and we need to figure out why.

因此，回到这里，让我们看一下我们的两种趋势，其中一种是在 10 名男士身上触发的，它让人充满活力，但并不能始终如一地充满活力。
So getting back into Here let's take a look at our two trends and this one set up to trigger on 10 men and it's energizing but it's not energizing consistently.

我想我可能知道这是为什么。
And I think I might know why that is.

当我返回调度程序时，我们每隔 10 分钟将其设置为 1。
When I go back into our scheduler we're setting this thing equal to one at a 10 minute interval.

但我们并没有做的就是将其设置回零。
But what we're not doing ever is setting it back to zero.

所以我认为这可能就是我们需要做的。
So I think that's probably what we need to do.

让我们试试这个。
Let's try this.

我不知道这个东西更新的频率，但让我们尝试一下。
I don't know how often this thing updates but let's try.

0 0 0 0 0 1 0 0 0。

0 0 0 0 0 1 0 0 0.

让我们每一秒都尝试一下。
Let's try it every second.

我们要把 10 个人归零。
We're going to set 10 men to zero.

但每 10 分钟一次，现在为了测试目的，我将在 10 秒而不是 10 分钟时执行此操作。
But every 10 minutes and for right now for test sake I'm going to do this at 10 seconds instead of 10 minutes.

假设每 10 秒我们就会将 10 个人设置为 1。
So let's say every 10 seconds then we're going to set ten men to one.

所以希望这能为这件事带来某种心跳。
So hopefully that will create kind of a heart beat for this thing.

我实际上知道有一种方法可以测试这个理论。
And I actually know there is a way we can test this theory.

我想来这里。
I want to come over here.

让我们在这里复制系统运行指示器，而不是查看 sists 的运行情况。
Let's just copy our system running indicator here and instead of looking at sists running.

让我们看看我的 10 分钟。
Let's look at my 10 min bit.

对于消息，我们只需将其设置为假或真。
And for messages we'll just set this up to say false or true.

希望我们能够看到这种脉冲，但它可能太快了，我们甚至看不到它。
And hopefully we'll be able to see that pulsing but it might be so fast we can't even see it.

但我只是创建这种数据库测试工具，所以也许这会帮助我们解决问题，也许不会。
But I'm just creating this kind of as a data base testing tool so maybe that'll help us troubleshoot it maybe it won't.

现在我们已经做到了，我认为我们在管理 10 分钟出价方面做得更好了。
So now we've got that and I think we're doing a bit better job of managing our 10 minute bid.

现在为什么我们没有得到反冲洗数据。
And now why are we not getting our backwash data.

那么让我们看看吧，让我们进入这里。
So let's see let's get into here.

我将关闭一些我们不使用的其他垃圾，并在反洗结束位通电时将其保存。
I'm going to close some of this other junk that we're not using and save that when our backwash ended bit is energized.

我们已经做到了。
We've got that.

让我们确保我们实际上指向了正确的位置，并且现在看起来我们没有指向任何地方。
And let's just make sure that we're actually pointing to the right place and it looks like right now we're not pointing anywhere.

所以我想我们甚至没有设置该标签，果然让我们回到我们的程序，那应该是 3 6 7。
So I guess we didn't even set that tag and sure enough let's go back into our program and that should be be 3 6 7.

那么让我们尝试在这里进行设置。
So let's try setting that up here.

B-3 科尔和六人最后七人。
B-3 Cole and six last seven.

这应该会有所作为。
And that should make a difference.

因此，让我们保存所有内容并继续进入运行模式。
So let's save everything and go ahead and go into run mode.

让我们看看现在是否正在收集任何数据。
And let's see if we're lugging any data now.

所以我要回到我们的欢迎屏幕。
So I'm going to go back to our welcome screen.

我要监视我们的 10 个人。
I'm going to monitor our 10 men bit.

这是错误的，我们应该看到它是真实的，否则我们可能不会。
It's false and we should see that pulsing true or maybe we won't.

每 10 秒一次。
Every 10 seconds.

我不知道那会多快。
I don't know how fast that'll be.

好的。
OK.

我们能够看到它。
We were able to see it.

这是一个很好的脉搏。
That's a good pulse.

我们现在实际上正处于反洗阶段，所以一旦完成，我们就应该创建反洗表，这样就应该有一些数据。
And we are actually in a backwash now so as soon as that completes right there we should have created our backwash tables so there should be some data.

让我们按 Alt-Tab 返回服务工作室。
Let's Alt-Tab back into service studio.

右键单击 P.L.
Right click on P.L.

3 刷新它，嘿，这是个好消息。
3 refresh it and hey that's good news.

我们现在实际上有一个反洗台。
We've actually got a backwash table now.

并检查那些顶部。
And check those top.

好的。
OK.

现在我们的反洗表中实际上已经有了一些数据。
Now we've actually got some data in our backwash table.

所以这是一件好事。
So that's a good thing.

好吧，我们喜欢这样。
And all right we like that.

现在让我们检查我们的定期数据，其中前 200 行，现在我们实际上每 10 秒创建一些数据，所以现在我们的数据记录正在工作。
And now let's check our periodic so top 200 rows of that and now we're actually creating some data every 10 seconds so now our data logging is working.

但对于这个项目，我应该每 10 分钟而不是每 10 秒进行一次 ADD 日志记录。
But for this project I'm supposed to have ADD logging every 10 minutes rather than every 10 seconds.

但让我们看看这个。
But let's just take a look at this.

截至目前二十至三十二。
As of right now twenty to thirty two.

而且我还进行了一些额外的日志记录。
And I'm also getting some extra logging happening.

我每 10 秒得到一次，但看起来我还每 1 秒得到一次，所以我得到 10 秒 11 秒之类的东西。
I'm getting it every 10 seconds but it looks like I'm also getting every one second on top of that so I'm getting 10 seconds 11 seconds sort of thing.

我有 1 个，然后是 11 个，但是 11 个之后我有 12 个。
I've got one and then 11 but after 11 I've got a 12.

所以看来我还没有记录我的数据。
So it looks like I'm still not logging my data.

非常正确。
Exactly right.

让我们回到应用程序。
Let's go back into the application.

让我们继续前进并阻止它。
Let's go ahead and stop it.

我认为这都与我们的调度程序有关。
And I think this is all has to do with our scheduler.

那么我们现在在这里发生了什么？
So what have we got going on in here right now.

好吧，走着瞧。
Well let's see.

我们正在拯救这个东西。
We are saving this thing.

这不是我们想看的。
That's not the one we want to look at.

我们想看看趋势一。
We want to look at trend one.

所以我只是要关闭一些额外的东西，在我的周期中，我们将其保存在 10 名男子的触发器上，而我们不会将其保存在标签更改上。
So I'm just going to close some of my extra stuff and on my periodic we are saving it on the trigger of 10 men and we're not saving that on tag change.

所以这是触发的。
So that is on trigger.

但由于某种原因，看起来它几乎保存了未标记的更改。
But for some reason it looks like it's almost saving it untagged change.

所以也许我们可以尝试一下。
So maybe we can try this.

让我们尝试在标签更改时保存它。
Let's try saving it on tag change.

看看这是否会产生影响，但我预计它会在这方面来回变化。
See if that makes a difference but then I would expect it's going to go back and forth on that.

所以我将尝试从这个开始。
So I'm just going to try that to start.

让我们继续前进，我什至不用担心查看我们的应用程序，我将立即回到我们的管理工作室，让我们看看这里发生了什么，所以我要关闭所有这些，到现在为止我认为我们可能已经获得了接近 10 秒的运行时间。
And let's go ahead and hit the run and I'm not even going to worry about looking at our application I'm going to go right back into our management studio and let's just see what's going on in here so I'm going to close all of that and by now I think we've probably got close to about 10 seconds worth of run time.

因此，让我们右键单击并检查我们的周期。
So let's right click and check our periodic.

现在我们开始。
And here we go.

我们在这里看什么。
What are we looking at here.

我们有 14 48 0 2 0 2。
We've got 14 48 0 2 0 2.

我认为我们正在研究新数据，我们得到了 45 46 55 56。
And here's where I think we're looking at new data and we've got 45 46 55 56.

是的，我认为我们仍然遇到同样的问题，但我不能百分百确定再给它几秒钟。
And yeah I think we've still got the same problem but I'm not 100 percent sure give it a few more seconds.

再次查看我的前 200 名，情况似乎没有变化。
Take my top 200 again and it doesn't look like that's changing.

因此，让我们选取前一千名，看看这是否有什么不同。
So let's take the top thousand and see if that makes any difference.

现在时间是10点50分。
Time right now is 10 50.

这显然认为现在是 2 点钟方向，因此显示的是 250，而不是 10 50。
And this obviously thinks it's 2 o'clock so it's showing 250 instead of 10 50.

是的，我仍然发现它看起来像是每秒，然后是 10 秒。
And yeah I'm still getting that it looks like every second and then 10 seconds.

让我们再试一次，看看我们是否得到了是的，我们得到了一些新的值，但仍然是同样的事情。
Let's try that one more time see if we've got Yeah we've got some new values and still the same thing.

我们肯定记录了太多数据，让我们离开这里。
We are definitely logging too much data Let's back out of here.

我将在我们离开之前关闭所有这些内容，让我们回到我们的应用程序，我将停止该应用程序，然后我想我也将返回管理工作室。
And I'm just going to close all of these out before we go let's get back into our app and I'm going to stop the app then I think I'm also going to go back into management studio.

我将删除该表，因为它将以任何方式重新创建，这样我们就不会被任何旧数据混淆。
I'm just going to delete that table because it's going to be recreated any way and that way we're not going to be confused by any old data.

那么，让我们回到内衣，我们可以节省标签更换的费用。
So let's go back into underwear and we're saving on tags change.

这似乎并没有多大区别。
That doesn't really seem to make much of a difference.

让我们每 10 秒尝试一次。
Let's try every 10 seconds.

将值设置为零，并且每 20 秒将值设置为 1。
Set the value to zero and every 20 seconds set the value to 1.

所以我只是想尝试找出 10 秒的间隔。
So I'm kind of just reaching for straws here and trying to figure out how to get a 10 second interval on that.

让我们运行一下，看看是否有更好的运气。
Let's run that up and see if we have any better luck.

我知道我们需要大约 10 秒的运行时间。
And I know we need about 10 seconds worth of run time on there.

所以我们得到的是假的。
So we've got false.

让我们稍后看看这个东西会做什么。
And let's just see what this thing does after a little bit.

我喜欢将其更改为 true，保持这种状态 10 秒钟。
I like for it to change to true stay that way for 10 seconds.

回到虚假。
Come back to false.

保持这个姿势 10 秒钟。
Stay that way for 10 seconds.

我确实看到了向 true 的良好过渡，我并不是在这里真正计算时间，而是如果。
And I did see the good transition to true and I'm not really counting time here but if.

是的。
Yeah.

好吧，我们得到了 false，看起来它的脉冲完全符合我想要的方式。
OK we've got false and it looks like it is pulsing exactly the way that I want.

现在的问题是反映我们实际获得的数据。
Now the question is is that reflecting the data that we're actually getting in here.

因此，让我们右键单击刷新数据库，再次检查我们的表。
So let's right click refresh our database again check our tables.

我们定期重新创建了 200 行，我们在这里看什么 14 53 我们有 12 和 12 13 和 13 14 和 15 和 15。
We've got our periodic recreated 200 rows and what are we looking at here 14 53 we've got 12 and 12 13 and 13 14 and 15 and 15.

所以现在看来​​我们实际上一直在拖着这个东西。
So it still looks like now it looks like we're actually lugging this thing all the time.

所以我认为我们是根据标签的变化而不是我们想要发生的事情来记录的，所以让我们再尝试一次。
So I think we're logging based on our tags changing rather than what we want to be happening so let's try this one more time.

我们将退出应用程序，然后删除我们的表。
We're going to exit out of the application and then delete our table.

我想我想我想我现在知道如何得到这个东西了。
And I think I think I think I know how to get this thing now.

现在让我们回到我们的趋势并将其保存在触发器上，就像我们进行萨沃尔跑步一样。
So now let's go back into our trend and save this on trigger like we were doing Savol run.

我想我们这次会喜欢它，我想我们终于解决了这个问题，而且它正在做我们想做的事情。
And I think we're going to like it this time I think we finally got this thing figured out and it's doing exactly what we wanted to do.

所以让我们等几秒钟。
So let's just give it a few seconds.

我们知道它需要大约 10 20 30 秒才能真正向我们展示正在做什么，然后让我们右键单击查看三。
We know it needs about 10 20 30 seconds to actually show us what is doing then let's right click on see three.

这不会刷新数据，但会刷新表结构，因此我们可以看到至少已经过了 10 秒，我们已经恢复了元素周期表。
And this doesn't refresh the data but it does refresh the table structure so we can see it has been at least 10 seconds and we've got our periodic table back.

现在我们应该已经有两到三个条目了。
And by now we should have had two or three entries.

让我们检查一下前 200 名。
So let's check that top 200.

我们在这里看到什么。
And what are we looking at here.

我们有36和46。
We've got 36 and 46.

如果我再次刷新并看到 56 和 0 6，那么我会告诉你我们得到了什么，我会非常高兴，因为那时我所要做的就是将计时器更改为 10 分钟，然后走开。
And if I refresh that again and see a 56 and 0 6 then I tell you what we've got it and I'm going to be so happy because then all I have to do is change that timer to 10 minutes and walk away.

这又是前 200 名，看起来我没有得到任何改变。
So that's that top 200 again and it doesn't look like I'm getting any change.

我停止录音了还是发生了什么。
So did I stop recording or what happened.

让我们选择前 1000 个。
Let's select top 1000.

这是我的最新数据。
There we go there's my fresh data.

三十六四十六五十七，这只是时间上的一些失误。
Thirty six forty six 57 which is just some slip on the time.

这不是什么大问题，因为它非常接近零毫秒。
That's not a big deal because it's so close to zero milliseconds.

但我们现在每 10 秒保存一次数据。
But we are now saving our data every 10 seconds.

这正是我们所需要的。
And that's exactly what we needed.

这样我就可以离开这里了。
So I can close out of here.

退出这个并回到我的日程安排中。
Exit out of this and go back into my schedule.

我唯一真正需要改变的是我的间隔。
The only thing I really need to change here is my interval.

所以这将是 10 分钟而不是 10 秒。
So that's going to be 10 minutes instead of 10 seconds.

这里的时间将是 20 分钟而不是 20 秒。
And this right here is going to be 20 minutes instead of 20 seconds.

就这样我得到了这个东西。
And just like that I've got this thing.

所以让我们继续拯救一切。
So let's go ahead and save all.

关闭这里，我将返回到我的欢迎屏幕并删除我在那里创建的这个小故障排除内容，因为我真的不需要它可见。
Close up out of here and I'm going to go back to my welcome screen and delete this little trouble shooting thing that I created there because I really don't need that to be visible.

就是这样。
And that's it.

这是一个正在运行且已完成的项目。
That is a working and finished project.

抱歉这个花了这么长时间。
Sorry this one took so long.

但是数据管理可能很棘手，我现在可能不需要告诉你，我什至不得不接触并放入调度程序和类似的东西。
But data management which I probably don't have to tell you at this point can be tricky and I even had to kind of reach and put in the scheduler and things like that.

但我们想通了。
But we figured it out.

我们让它工作了，这就是程序员所做的。
We got it working and that's what a programmer does.

你总是会发现新的东西。
You're always going to find something new.

并不总是会有人握住你的手并教你这些东西。
There's not always going to be someone to hold your hand and teach you this stuff.

当它发生时，我们点击谷歌，我们搜索，我们进入帮助菜单，我们进行尝试和错误，这就是你刚刚在这里看到的。
And when it happens we hit Google we search we go into Help menus we do trial and error and that's kind of what you just saw here.

这才是真正的编程宝贝。
So that's real programming baby.

看起来就是这样。
That's how it looks.

无论如何，我们就完成了。
Anyway that's it we're done.

这里没有更多的项目了。
No more projects here.

这门课已经基本完成了。
Pretty much done with this course.

在你获得证书的路上，我会在下一堂课中见到你，我们会说再见。
And on your way to a certificate so I will see you in the next lecture and we'll say our goodbyes.

所以直到那时欢呼
So until then cheers